Sample formulas using fields

The formula in this example uses the Xtreme database. To find out how many days it takes to ship the product from the date when the order was placed, subtract the ship date database field from the order date database field:

Rem A formula that uses database fields
formula = {Orders.Ship Date} - {Orders.Order Date}

To find the total dollar amount of a given product that was ordered, multiply its unit price by the quantity ordered:

formula = {Orders Detail.Unit Price} * _
          {Orders Detail.Quantity}

Note:    The example uses the line continuation character " _ " (space underscore). See Statements (Basic syntax).

To calculate a sale price of 80 percent of the original unit price:

formula = {Orders Detail.Unit Price} * 0.80



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com